﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Test123.aspx.cs" Inherits="Test123" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        <asp:DataList ID="DataList1" runat="server" DataKeyField="Pro_ID" 
            DataSourceID="SqlDataSource1">
            <ItemTemplate>
                Pro_ID:
                <asp:Label ID="Pro_IDLabel" runat="server" Text='<%# Eval("Pro_ID") %>' />
                <br />
                Code:
                <asp:Label ID="CodeLabel" runat="server" Text='<%# Eval("Code") %>' />
                <br />
                Sub_Cat:
                <asp:Label ID="Sub_CatLabel" runat="server" Text='<%# Eval("Sub_Cat") %>' />
                <br />
                Cat_ID:
                <asp:Label ID="Cat_IDLabel" runat="server" Text='<%# Eval("Cat_ID") %>' />
                <br />
                Description:
                <asp:Label ID="DescriptionLabel" runat="server" 
                    Text='<%# Eval("Description") %>' />
                <br />
                Pro_Name:
                <asp:Label ID="Pro_NameLabel" runat="server" Text='<%# Eval("Pro_Name") %>' />
                <br />
                Pro_Price:
                <asp:Label ID="Pro_PriceLabel" runat="server" Text='<%# Eval("Pro_Price") %>' />
                <br />
                Ret_Price:
                <asp:Label ID="Ret_PriceLabel" runat="server" Text='<%# Eval("Ret_Price") %>' />
                <br />
                Pur_Price:
                <asp:Label ID="Pur_PriceLabel" runat="server" Text='<%# Eval("Pur_Price") %>' />
                <br />
                Point_Value:
                <asp:Label ID="Point_ValueLabel" runat="server" 
                    Text='<%# Eval("Point_Value") %>' />
                <br />
                Pro_Type:
                <asp:Label ID="Pro_TypeLabel" runat="server" Text='<%# Eval("Pro_Type") %>' />
                <br />
<br />
            </ItemTemplate>
        </asp:DataList>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:MainConnStr %>" 
            SelectCommand="SELECT [Pro_ID], [Code], [Sub_Cat], [Cat_ID], [Description], [Pro_Name], [Pro_Price], [Ret_Price], [Pur_Price], [Point_Value], [Pro_Type] FROM [Tbl_Product]">
        </asp:SqlDataSource>
    
    </div>
    </form>
</body>
</html>
